These functions in this section perform calculations on a series of values. The  Average,  Max,  Min,  Sum, Sum squares, Std deviation, and  Variance functions can be applied to fields or subfields. In the case of a field, they are applied to a selection of records. In the case of a subfield, they are applied to a selection of the subrecords of the current record. Note that the Sum squares, Std deviation, and  Variance functions can be used on a field only during printing.
 Average
 Max
 Min
 Sum
Std deviation
Sum squares
 Variance
These functions work on numeric data only. Each of these functions returns a numeric value.
Using a Field
When  Average,  Max,  Min, or  Sum are used on a field, they must load each record in the current selection to calculate the result. If there are many records, this process may take some time.
When these functions are used in a report, they behave differently than at other times. This is because the report itself must load each record. Use these functions in a layout procedure or script when you are printing with the PRINT SELECTION command or when you are printing in the User environment by choosing Print from the File menu.
When you use these functions in a report, the values that are returned are reliable only at break level 0. Break processing should be turned on. This means that they are useful only at the end of a report after all the records have been processed. You only use the functions in a script for a non-enterable area that is included in the B0 Break area. The script assigns the value returned to the variable associated with the area.
